| Tanel Poder Masterclass (UK) - Oracle Partitioning and parallel Execution for Performance |
|
|
|
Friday, 4. June 2010, 09:00 - 17:00 |
|
|
|
Oracle Partitioning and Parallel Execution for PerformanceTanel will be in 2010 in
* London (UK) - 4 June 2010 (Click here to register)
* Utrecht (NL) - 10 June 2010 (Click here to register)
* Brussel (BE) - not decided yet Seminar overviewOracle Database’s partitioning options can be used for help in three areas: VLDB information lifecycle manageability, data availability and performance. This seminar will mostly cover partitioning for performance, how to design partitioning for performance and how to write/troubleshoot SQL which should use partitioning for performance.
The second part of this section will cover parallel execution internals, tuning and troubleshooting, both in partitioned and non-partitioned environments and we also touch the topic of configuring parallel execution right on RAC.
Seminar Duration and Details
Seminar duration: 1 day
Audience: Senior DBAs, senior developers, database designers
Skill level: Intermediate to Advanced
You will learn the following…
· Best practices for partitioning (in different circumstances) and how to avoid common pitfalls
· How to control partition pruning and measure whether desired partition pruning is happening
· How to achieve serial partition wise joins for joining large datasets
· Understand how the parallel execution engine and row distribution works
· Best practices for parallelism (in different circumstances) and how to avoid common pitfalls
· How to troubleshoot Parallel execution plans and see exactly where the bottleneck is
Table of contents
Designing applications and databases with partitioning in mind
· Designing for partition pruning
· Designing for serial Partition wise joins
· Choosing between local vs. global indexes
· Partitioned objects, CBO and optimizer statistics collection
Troubleshooting partition pruning
· Measuring which exact partitions are visited during the SQL execution
· Why isn’t the desired partition pruning happening?
Understanding data flow in parallel execution plans
· Understanding producer-consumer hierarchy
· Monitoring data distribution and table queues
Achieving optimal data distribution in parallel execution plans
· Avoiding data broadcasts and many-to-many distribution
· Combining multiple rowsource operators onto a single level in parallel execution hierarchy
· Parallel partition-wise joins
· Best PX distribution for partitioned tables
· Parallel execution considerations in RAC
Advanced Parallel Execution Troubleshooting
· Tracing parallel execution and gathering detailed parallel execution stats
· Monitoring IO throughput and detecting IO subsystem saturation
Oracle Partitioning and Parallel Execution for Performance seminar by Tanel Poder
http://blog.tanelpoder.com | http://tech.e2sn.com |
Location: London (UK)
Contact: Annette Herruer - 0641788142 |
Back
|
